package com.project.dto;

import java.io.Serializable;

/*
 * CREATE TABLE tpic (
	email VARCHAR2(40),
	pdate VARCHAR2(50),
	pcode NUMBER, 
	pname VARCHAR2(50), 
	pcontent VARCHAR2(4000), 
	pref NUMBER, 
	pdepth NUMBER, 
	pparent NUMBER, 
	pstep NUMBER,
	pdel VARCHAR2(2),	
	pboard VARCHAR2(50)
);

ALTER TABLE tpic
	ADD
		CONSTRAINT tpic_PK
		PRIMARY KEY (
			email,
			pdate
		);

ALTER TABLE tpic
	ADD
		CONSTRAINT member_TO_tpic_FK
		FOREIGN KEY (
			email
		)
		REFERENCES member (
			email
		);
	CREATE SEQUENCE TPIC_SEQ START WITH 1 INCREMENT BY 1;

 */


public class TPicDto implements Serializable {
	private String email;
	private String pdate;
	private int pcode; 
	private String pname;
	private String pcontent; 
	private int pref; 
	private int pdepth; 
	private int pparent; 
	private int pstep;
	private String pdel;
	private String pboard;
	
	public TPicDto() {
		super();		
	}

	public TPicDto(String email, String pdate, int pcode, String pname,
			String pcontent, int pref, int pdepth, int pparent, int pstep,
			String pdel,String pboard) {
		super();
		this.email = email;
		this.pdate = pdate;
		this.pcode = pcode;
		this.pname = pname;
		this.pcontent = pcontent;
		this.pref = pref;
		this.pdepth = pdepth;
		this.pparent = pparent;
		this.pstep = pstep;
		this.pdel = pdel;
		this.pboard = pboard;
	}

	public String getEmail() {
		return email;
	}

	public void setEmail(String email) {
		this.email = email;
	}

	public String getPdate() {
		return pdate;
	}

	public void setPdate(String pdate) {
		this.pdate = pdate;
	}

	public int getPcode() {
		return pcode;
	}

	public void setPcode(int pcode) {
		this.pcode = pcode;
	}

	public String getPname() {
		return pname;
	}

	public void setPname(String pname) {
		this.pname = pname;
	}

	public String getPcontent() {
		return pcontent;
	}

	public void setPcontent(String pcontent) {
		this.pcontent = pcontent;
	}

	public int getPref() {
		return pref;
	}

	public void setPref(int pref) {
		this.pref = pref;
	}

	public int getPdepth() {
		return pdepth;
	}

	public void setPdepth(int pdepth) {
		this.pdepth = pdepth;
	}

	public int getPparent() {
		return pparent;
	}

	public void setPparent(int pparent) {
		this.pparent = pparent;
	}

	public int getPstep() {
		return pstep;
	}

	public void setPstep(int pstep) {
		this.pstep = pstep;
	}

	public String getPdel() {
		return pdel;
	}

	public void setPdel(String pdel) {
		this.pdel = pdel;
	}
	
	public String getPboard() {
		return pboard;
	}

	public void setPboard(String pboard) {
		this.pboard = pboard;
	}

	@Override
	public String toString() {
		return "TPicDto [email=" + email + ", pdate=" + pdate + ", pcode="
				+ pcode + ", pname=" + pname + ", pcontent=" + pcontent
				+ ", pref=" + pref + ", pdepth=" + pdepth + ", pparent="
				+ pparent + ", pstep=" + pstep + ", pdel=" + pdel + ",pboard=" + pboard + "]";
	}	
}
